UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZvUMUskRcVn4qESRe9/qllcVY2JLVkWIXDCIrFvDq0A='
WHERE
key_id = 'caffdca90a15ae9ef0c982ddf2427467b104c65a3a4c0403c24822ae53c4b76a'
AND (
token = 'ZvUMUskRcVn4qESRe9/qllcVY2JLVkWIXDCIrFvDq0A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)