UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C4r1hiyXqMjYR3MlIxthe7W+VhNFawt56QwcnEx7bSM='
WHERE
key_id = '116161d4cd6be1cf69d2edf247c33a09a358084d37e62308a9ebf3d50c35e185'
AND (
token = 'C4r1hiyXqMjYR3MlIxthe7W+VhNFawt56QwcnEx7bSM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)