UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TFpN5X6jwpcNMxsiub3hnI1b4EF9saUcxFU2X6D1p2E='
WHERE
key_id = '03df9a06d458e750755c0401b434b3cd177c111ef7db4aca63918c0d3017d3c7'
AND (
token = 'TFpN5X6jwpcNMxsiub3hnI1b4EF9saUcxFU2X6D1p2E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)