UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ha7f/sSt3aU/SPiUb71eU2uoSOOmQ3ZvqfVlK9+zSNo=' 
WHERE 
  key_id = '897e22400d3e9b33495392c7228a34833ad71f94fce8b48ed17c0c6da55405b8' 
  AND (
    token = 'ha7f/sSt3aU/SPiUb71eU2uoSOOmQ3ZvqfVlK9+zSNo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040