UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jB9fHO4fpdZw5muvNck9qLV9KiaNHaWYVPV+8tgkono='
WHERE
key_id = '80273588547b538ce2afd9daa9a16c0b4d3d8370d221cc69f01f4e9f121d50d4'
AND (
token = 'jB9fHO4fpdZw5muvNck9qLV9KiaNHaWYVPV+8tgkono='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)