UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zvaSikDD5yZqd4gcWUGeqSjZbQnxjf9w1vMsgsO+CLA='
WHERE
key_id = 'f8b064bb63d57fe273f8daa91092760ebc3415362380d1db5c12c0d835a0165a'
AND (
token = 'zvaSikDD5yZqd4gcWUGeqSjZbQnxjf9w1vMsgsO+CLA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)