UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QpeiwvqZZUYMDmJ/jXAg3bOv0KEiHC6AJZ3ijsJ48RY='
WHERE
key_id = 'b9e4bedda722a8e2682ed5f597f9478bc6e684190b63f14eed0576710241b6cc'
AND (
token = 'QpeiwvqZZUYMDmJ/jXAg3bOv0KEiHC6AJZ3ijsJ48RY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)