UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x5PjHXLnBgJBkrJ3Tr6r/hJLUkikZYyoa/cnsfOtYOY='
WHERE
key_id = '8a7a99312acb2fdaba2a7b8c7720def093e325dc10619ace15aa894cb19e62bf'
AND (
token = 'x5PjHXLnBgJBkrJ3Tr6r/hJLUkikZYyoa/cnsfOtYOY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)