UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1QFW1nGrsKJJISxsvJp02wUBUJSoLmKTWmaBGu1I5eI='
WHERE
key_id = '7e1dab07e4b5b696be5e397d03f5a4f6f10ab8ec67ff796d9167de12c96a756e'
AND (
token = '1QFW1nGrsKJJISxsvJp02wUBUJSoLmKTWmaBGu1I5eI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)