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