UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CQnMr+iEoIVKzJ0YyGOc4BDSXro1rsA4naQ759kKk8A='
WHERE
key_id = 'f403ecbac767e9243e79c246810f71c87f5953e60f74a546083f8b9e2598b457'
AND (
token = 'CQnMr+iEoIVKzJ0YyGOc4BDSXro1rsA4naQ759kKk8A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)