UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R9tS0RE9GwDdNVmC0IBGXq8tLVGS73TMNxY8wS1a7v0='
WHERE
key_id = '95a926194929cb1c84bcaba3d4050ab45ea8c7cb9ec2b4e7a68ce07564f849bf'
AND (
token = 'R9tS0RE9GwDdNVmC0IBGXq8tLVGS73TMNxY8wS1a7v0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)