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