UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pt299QC6ZF8uR4Aegi4uws84mPTbv0riWS8acPmUNww='
WHERE
key_id = '604c14381e36bcb6ec2523ae1ce6540875e85957861b5276e0d91ff44bbc1a59'
AND (
token = 'pt299QC6ZF8uR4Aegi4uws84mPTbv0riWS8acPmUNww='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)