SELECT 
  * 
FROM 
  cscart_logos 
WHERE 
  IF(
    layout_id = 0, 
    1, 
    IF(layout_id = 2, 1, 0)
  ) 
  AND IF(
    style_id = '', 
    1, 
    IF(style_id = 'Baubay', 1, 0)
  ) 
  AND company_id = 1

Query time 0.00049

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

Result

logo_id layout_id company_id type style_id
69 0 1 gift_cert
72 2 1 theme Baubay
73 2 1 favicon Baubay
74 0 1 mail Baubay
75 0 1 gift_cert Baubay