SELECT 
  object_id 
FROM 
  cscart_settings_objects 
  LEFT JOIN cscart_settings_sections ON cscart_settings_objects.section_id = cscart_settings_sections.section_id 
WHERE 
  cscart_settings_objects.name = 'pinta_social_login_pop_up_status' 
  AND cscart_settings_sections.name = 'pinta_social_login'

Query time 0.00024

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_settings_objects ref name,section_id name 386 const 1 Using index condition
1 SIMPLE cscart_settings_sections eq_ref PRIMARY PRIMARY 4 cscart_dev_4_16.cscart_settings_objects.section_id 1 Using where

Result

object_id
6396