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