UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NvAb3S0cCnaUpNFME+iQ0EDgOSJ3MrCpM4fmPPZ0BQk='
WHERE
key_id = '9f38fc5b0ea47de222dfa594f9cda6fd0fb3f5c7312215602132d929b1c8d767'
AND (
token = 'NvAb3S0cCnaUpNFME+iQ0EDgOSJ3MrCpM4fmPPZ0BQk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)