UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KToSiYFpEt9KUhLB3uMQWilXbI3iTfH91VYa0qQf428='
WHERE
key_id = '6cf2ec8e3cbc83e1c6f6a0d0c408103269d926f3023ba45248e90b4f7ad1610b'
AND (
token = 'KToSiYFpEt9KUhLB3uMQWilXbI3iTfH91VYa0qQf428='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)