UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ROG9AF5bYIEiKsS5CekkgYo08dpOwuqU/21+AYXpCl8='
WHERE
key_id = '1bf509fd8b51f856c214cc7b50a8aa19138e1d9bdacfd834d180bff1be179cea'
AND (
token = 'ROG9AF5bYIEiKsS5CekkgYo08dpOwuqU/21+AYXpCl8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)