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