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