UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lgs5kOHrkOMcwidBdSkryaRcJnX9SQS/qBSvECfLloE='
WHERE
key_id = 'd27ded5be72962c0fa0cd47b59f018cb09bb8624021e3e5d3223f85423d96560'
AND (
token = 'lgs5kOHrkOMcwidBdSkryaRcJnX9SQS/qBSvECfLloE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)