UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'veqVEt7njdGH99wgju7muQw9dzp362HVRHa09Wogh/k='
WHERE
key_id = '8f5cfd61bf6783bc2e1d6221b1fad367c4925a58d2c94387f3afa8ebb8bf28d8'
AND (
token = 'veqVEt7njdGH99wgju7muQw9dzp362HVRHa09Wogh/k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)