SELECT 
  cscart_settings_objects.object_id as object_id, 
  name, 
  section_id, 
  section_tab_id, 
  type, 
  position, 
  is_global, 
  cscart_settings_objects.name as description, 
  (
    CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_settings_objects.value END
  ) AS value 
FROM 
  cscart_settings_objects 
  LEFT JOIN cscart_settings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_settings_objects.object_id 
  AND storefront_values.storefront_id = 1 
  AND storefront_values.company_id = 0 
WHERE 
  1 
  AND section_id = 62 
  AND (
    FIND_IN_SET(
      'STOREFRONT', cscart_settings_objects.edition_type
    ) 
    OR FIND_IN_SET(
      'ROOT', cscart_settings_objects.edition_type
    ) 
    OR FIND_IN_SET(
      'MVE:STOREFRONT', cscart_settings_objects.edition_type
    ) 
    OR FIND_IN_SET(
      'MVE:ROOT', cscart_settings_objects.edition_type
    )
  ) 
  AND cscart_settings_objects.type <> 'H' 
ORDER BY 
  cscart_settings_objects.position

Query time 0.00025

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE storefront_values system PRIMARY,storefront_id,company_id 0 const row not found
1 SIMPLE cscart_settings_objects ref section_id section_id 4 const 16 Using where; Using filesort

Result

object_id name section_id section_tab_id type position is_global description value
5795 notice 62 63 O 0 N notice
5810 forbidden_countries_notice 62 64 O 0 N forbidden_countries_notice
5811 forbidden_countries 62 64 B 10 N forbidden_countries #M#CN=Y&CG=Y&IR=Y
5797 recaptcha_site_key 62 63 I 20 N recaptcha_site_key
5798 recaptcha_secret 62 63 I 30 N recaptcha_secret
5799 recaptcha_theme 62 63 S 40 N recaptcha_theme light
5800 recaptcha_size 62 63 S 50 N recaptcha_size normal
5801 recaptcha_type 62 63 S 60 N recaptcha_type image
5803 recaptcha_v3_site_key 62 63 I 80 N recaptcha_v3_site_key
5804 recaptcha_v3_secret 62 63 I 90 N recaptcha_v3_secret
5805 recaptcha_v3_success_score 62 63 S 100 N recaptcha_v3_success_score 0.5
5807 recaptcha_use_for_value 62 63 D 120 N recaptcha_use_for_value
5808 recaptcha_use_for 62 63 E 130 N recaptcha_use_for use_for_settings.tpl
5809 settings_proxy 62 63 O 140 N settings_proxy