SELECT 
  lang.name, 
  lang.value 
FROM 
  cscart_language_values lang 
WHERE 
  lang.lang_code = 'ru' 
  AND lang.name IN (
    'general', 'location', 'geo_maps.your_city', 
    'edit_profile', 'mb_profile_login.password_page_title', 
    'mb_profile_login.address_book_title', 
    'help', 'my_changes.header.policies', 
    'cp_terms_n_conditions_name', 'cp_terms_privacy_name', 
    'cp_terms_marketing_name', 'mb_profile_login.menu_support_center', 
    'my_changes.header.help_support', 
    'general', 'location', 'geo_maps.your_city', 
    'edit_profile', 'mb_profile_login.password_page_title', 
    'mb_profile_login.address_book_title', 
    'help', 'my_changes.header.policies', 
    'cp_terms_n_conditions_name', 'cp_terms_privacy_name', 
    'cp_terms_marketing_name', 'mb_profile_login.menu_support_center', 
    'my_changes.header.help_support'
  )

Query time 0.00041

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "lang",
      "access_type": "range",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "392",
      "used_key_parts": ["lang_code", "name"],
      "rows": 13,
      "filtered": 100,
      "index_condition": "lang.lang_code = 'ru' and lang.`name` in ('general','location','geo_maps.your_city','edit_profile','mb_profile_login.password_page_title','mb_profile_login.address_book_title','help','my_changes.header.policies','cp_terms_n_conditions_name','cp_terms_privacy_name','cp_terms_marketing_name','mb_profile_login.menu_support_center','my_changes.header.help_support','general','location','geo_maps.your_city','edit_profile','mb_profile_login.password_page_title','mb_profile_login.address_book_title','help','my_changes.header.policies','cp_terms_n_conditions_name','cp_terms_privacy_name','cp_terms_marketing_name','mb_profile_login.menu_support_center','my_changes.header.help_support')"
    }
  }
}