UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XIdqnTdiJgBX3w1LWqC8oEHV0rnqCpABiUeTwgFxtJM='
WHERE
key_id = 'ae9ee6c71782619ec07228785173af7829350d494579afbcf5868a0787758b4a'
AND (
token = 'XIdqnTdiJgBX3w1LWqC8oEHV0rnqCpABiUeTwgFxtJM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)