Sandbox

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

Query time 0.00095

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

Result

logo_id	layout_id	style_id	company_id	type	storefront_id
13	0		3	theme	0
14	0		3	mail	0