Sandbox

SELECT 
  cscart_payments.*, 
  cscart_payment_descriptions.*, 
  IF (
    ISNULL(cscart_addons.status), 
    "A", 
    cscart_addons.status
  ) AS processor_status, 
  cscart_payment_processors.type AS processor_type, 
  cscart_payment_processors.processor_script AS processor_script 
FROM 
  cscart_payments 
  LEFT JOIN cscart_payment_descriptions ON cscart_payment_descriptions.payment_id = cscart_payments.payment_id 
  AND cscart_payment_descriptions.lang_code = 'en' 
  LEFT JOIN cscart_payment_processors ON cscart_payment_processors.processor_id = cscart_payments.processor_id 
  LEFT JOIN cscart_addons ON cscart_payment_processors.addon = cscart_addons.addon 
  LEFT JOIN cscart_storefronts_payments AS storefronts_payments ON storefronts_payments.payment_id = cscart_payments.payment_id 
WHERE 
  cscart_payments.status = 'A' 
  AND (
    storefronts_payments.storefront_id = 1 
    OR storefronts_payments.storefront_id IS NULL
  ) 
  AND cscart_payment_processors.processor_script IN ('stripe.php') 
HAVING 
  processor_status = 'A' 
ORDER BY 
  cscart_payments.position

Query time 0.00040

Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cscart_payments	ALL					5	Using where; Using temporary; Using filesort
1	SIMPLE	cscart_payment_descriptions	eq_ref	PRIMARY	PRIMARY	9	toolboxdigitalshop_dev.cscart_payments.payment_id,const	1	Using where
1	SIMPLE	cscart_payment_processors	eq_ref	PRIMARY	PRIMARY	3	toolboxdigitalshop_dev.cscart_payments.processor_id	1	Using where
1	SIMPLE	cscart_addons	eq_ref	PRIMARY	PRIMARY	98	toolboxdigitalshop_dev.cscart_payment_processors.addon	1	Using where
1	SIMPLE	storefronts_payments	index		PRIMARY	8		5	Using where; Using index; Using join buffer (flat, BNL join)