SELECT 
  * 
FROM 
  cscart_settings_sections 
WHERE 
  name = 'vendor_communication' 
  AND type = 'ADDON' 
  AND (
    FIND_IN_SET(
      'STOREFRONT', cscart_settings_sections.edition_type
    ) 
    OR FIND_IN_SET(
      'ROOT', cscart_settings_sections.edition_type
    ) 
    OR FIND_IN_SET(
      'MVE:STOREFRONT', cscart_settings_sections.edition_type
    ) 
    OR FIND_IN_SET(
      'MVE:ROOT', cscart_settings_sections.edition_type
    )
  )

Query time 0.00031

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_settings_sections ALL 152 Using where

Result

section_id parent_id edition_type name position type
46 0 ROOT,STOREFRONT vendor_communication 0 ADDON