UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '12/Q9lJT85pQB9VvXc9+8/jbH5VAHWEhOe0yU9YUPSo='
WHERE
key_id = 'c8eb0eecb0a81ebf4811fc84ab769ba020b3b4dc9f7204d7e3f36626ca479c3b'
AND (
token = '12/Q9lJT85pQB9VvXc9+8/jbH5VAHWEhOe0yU9YUPSo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)