UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X8SZxXGE7ManR071JHVC6aibyTlC4qGcvbhtXzyopZo='
WHERE
key_id = '83ca59b545f2fbe8f392955bfe581613c6e6bb69f4904b76875562d1e98c95e7'
AND (
token = 'X8SZxXGE7ManR071JHVC6aibyTlC4qGcvbhtXzyopZo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)