UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nRrZHzOd0t+umoeZiVoAoHIR1/HCOrbz7qi7g5wpueU='
WHERE
key_id = '16658336501ceef979ead4c78533ae6f37d93e8d416758e04e7f847c69cfd05e'
AND (
token = 'nRrZHzOd0t+umoeZiVoAoHIR1/HCOrbz7qi7g5wpueU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)