UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jXUbefgHFM6pePCJbE0noPB49AMeaibh4xteFDWxvSw='
WHERE
key_id = 'e549f6a8c98cb823adc2ca48f07e16c7c923bcdc753b1ac96d7541b04f7d8c7c'
AND (
token = 'jXUbefgHFM6pePCJbE0noPB49AMeaibh4xteFDWxvSw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)