SELECT 
  * 
FROM 
  cscart_settings_sections 
WHERE 
  name = 'seo' 
  AND type = 'ADDON' 
  AND (
    FIND_IN_SET(
      'ROOT', cscart_settings_sections.edition_type
    ) 
    OR FIND_IN_SET(
      'ULT:ROOT', cscart_settings_sections.edition_type
    ) 
    OR FIND_IN_SET(
      'VENDOR', cscart_settings_sections.edition_type
    ) 
    OR FIND_IN_SET(
      'ULT:VENDOR', cscart_settings_sections.edition_type
    )
  )

Query time 0.00024

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

Result

section_id parent_id edition_type name position type
287 0 ROOT,ULT:VENDOR seo 0 ADDON