Sandbox

SELECT 
  category_id 
FROM 
  cscart_categories 
WHERE 
  category_id = 734 
  AND (
    usergroup_ids = '' 
    OR FIND_IN_SET(0, usergroup_ids) 
    OR FIND_IN_SET(1, usergroup_ids)
  ) 
  AND status IN ('A', 'H') 
  AND cscart_categories.storefront_id IN (0, 1)

Query time 0.00030

Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cscart_categories	const	PRIMARY,c_status,p_category_id	PRIMARY	3	const	1

Result

category_id
734