UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6wcyZK4IvXfHXayt88sy6wQ9F4SPvzx26mMZEoIp9H4='
WHERE
key_id = '01f5b344c7d42758c96b414a04fa4063114e2d7b47387cb223ca7434a8752ff1'
AND (
token = '6wcyZK4IvXfHXayt88sy6wQ9F4SPvzx26mMZEoIp9H4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)