UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YXx78OK4d/iXefZCQ7zMz3VrxD8AfukLzuMxU0aOAa8='
WHERE
key_id = '20c419672fdd337fb8075415a9074acba96b5a3440d9d3a298d65eaa34320186'
AND (
token = 'YXx78OK4d/iXefZCQ7zMz3VrxD8AfukLzuMxU0aOAa8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)