Sandbox

SELECT 
  * 
FROM 
  cscart_logos 
WHERE 
  layout_id IN (1, 0) 
  AND style_id IN ('Bright_theme', '') 
  AND storefront_id IN (1, 0) 
  AND company_id = 1

Query time 0.00024

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

Result

logo_id	layout_id	style_id	company_id	type	storefront_id
1	1	Bright_theme	1	theme	1
2	1	Bright_theme	1	favicon	1
3	1	Bright_theme	1	mail	1