UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zCkOIgnIBuY5AnDQ98qtQfkqTRMOsImaeu6l65R+mi4='
WHERE
key_id = 'fb1d8a27b3b35104037b4dea0615af022e972ce9adf720e53f77d8625194c31a'
AND (
token = 'zCkOIgnIBuY5AnDQ98qtQfkqTRMOsImaeu6l65R+mi4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)