UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0RG4JBWl4v7I3iOeP/ODGj2zX8A7Lei5GzBMYCXaRzc='
WHERE
key_id = 'b18bcfb0e10c45e6357edb58c735f4f7e4e4bb8bd39c59f0bbc49e72ccd97dfa'
AND (
token = '0RG4JBWl4v7I3iOeP/ODGj2zX8A7Lei5GzBMYCXaRzc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)