UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hF9J8n4zZp6dGjJVVPEV2Ndwm3oLK9C+b2vhEEvd31U='
WHERE
key_id = '9130ed14c4a8801aeec6df4e258378cae601a54efac3fc5824b03870d6d08010'
AND (
token = 'hF9J8n4zZp6dGjJVVPEV2Ndwm3oLK9C+b2vhEEvd31U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)