Sandbox

SELECT 
  b.variant_name, 
  a.*, 
  IF(
    shared_option_variants.variant_id IS NOT NULL, 
    shared_option_variants.modifier, 
    a.modifier
  ) as modifier, 
  IF(
    shared_option_variants.variant_id IS NOT NULL, 
    shared_option_variants.modifier_type, 
    a.modifier_type
  ) as modifier_type 
FROM 
  cscart_product_option_variants AS a 
  LEFT JOIN cscart_product_option_variants_descriptions AS b ON b.variant_id = a.variant_id 
  AND b.lang_code = 'en' 
  LEFT JOIN cscart_ult_product_option_variants shared_option_variants ON shared_option_variants.variant_id = a.variant_id 
  AND shared_option_variants.company_id = 1 
WHERE 
  1 
  AND a.option_id IN (
    85910, 85907, 85906, 85905, 85904, 85903, 
    85902, 85901, 85900, 85896, 86510, 
    86317, 86316, 86315, 86314, 85834, 
    96653, 96652, 96651, 96650
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00111

Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	range	status,option_id,option_id_2	option_id	6		40	Using index condition; Using filesort
1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	9	toolboxdigitalshop_dev.a.variant_id,const	1	Using where
1	SIMPLE	shared_option_variants	eq_ref	PRIMARY,company_id	PRIMARY	7	toolboxdigitalshop_dev.a.variant_id,const	1

Result

variant_name	variant_id	option_id	position	modifier	modifier_type	weight_modifier_type	point_modifier_type	status
MP3	172204	85834	1	0.000	A	A	A	A
MP3	172328	85896	1	0.000	A	A	A	A
MP3	172336	85900	1	0.000	A	A	A	A
MP3	172338	85901	1	0.000	A	A	A	A
MP3	172340	85902	1	0.000	A	A	A	A
MP3	172342	85903	1	0.000	A	A	A	A
MP3	172344	85904	1	0.000	A	A	A	A
MP3	172346	85905	1	0.000	A	A	A	A
MP3	172348	85906	1	0.000	A	A	A	A
MP3	172350	85907	1	0.000	A	A	A	A
MP3	172356	85910	1	0.000	A	A	A	A
MP3	173164	86314	1	0.000	A	A	A	A
MP3	173166	86315	1	0.000	A	A	A	A
MP3	173168	86316	1	0.000	A	A	A	A
MP3	173170	86317	1	0.000	A	A	A	A
MP3	173556	86510	1	0.000	A	A	A	A
MP3	193836	96650	1	0.000	A	A	A	A
MP3	193838	96651	1	0.000	A	A	A	A
MP3	193840	96652	1	0.000	A	A	A	A
MP3	193842	96653	1	0.000	A	A	A	A
WAV	172205	85834	2	0.300	A	A	A	A
WAV	172329	85896	2	0.300	A	A	A	A
WAV	172337	85900	2	0.300	A	A	A	A
WAV	172339	85901	2	0.300	A	A	A	A
WAV	172341	85902	2	0.300	A	A	A	A
WAV	172343	85903	2	0.300	A	A	A	A
WAV	172345	85904	2	0.300	A	A	A	A
WAV	172347	85905	2	0.300	A	A	A	A
WAV	172349	85906	2	0.300	A	A	A	A
WAV	172351	85907	2	0.300	A	A	A	A
WAV	172357	85910	2	0.300	A	A	A	A
WAV	173165	86314	2	0.300	A	A	A	A
WAV	173167	86315	2	0.300	A	A	A	A
WAV	173169	86316	2	0.300	A	A	A	A
WAV	173171	86317	2	0.300	A	A	A	A
WAV	173557	86510	2	0.300	A	A	A	A
WAV	193837	96650	2	0.300	A	A	A	A
WAV	193839	96651	2	0.300	A	A	A	A
WAV	193841	96652	2	0.300	A	A	A	A
WAV	193843	96653	2	0.300	A	A	A	A