UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6qz9I/7RygtTJAXXoOQQecVJvgVT5SYKxbRjML6nLtU='
WHERE
key_id = 'b4f608693c7578b7d16a064b22d6b16a48f14ff1cb303a68b852ed6e75cc5d48'
AND (
token = '6qz9I/7RygtTJAXXoOQQecVJvgVT5SYKxbRjML6nLtU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)