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