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