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

Query time 0.00099

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

Result

logo_id layout_id style_id company_id type storefront_id
12 0 0 gift_cert 1
42 2 Posh 0 favicon 1
41 2 Posh 0 theme 1
43 2 Posh 0 mail 1
44 2 Posh 0 vendor 1