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 (
    68367, 68247, 68001, 68000, 68528, 68527, 
    68526, 68285, 68246, 68476, 68475, 
    68474, 68473, 67979, 68411, 68242, 
    66888, 64089, 43836, 38897, 38896, 
    36750, 68398, 68397, 68379, 68366, 
    68364, 68345, 68286, 68250, 67999, 
    67998, 67995, 67215, 66900, 66691, 
    66690, 66689, 66688, 68154
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00114

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		80	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	73566	36750	1	0.000	A	A	A	A
MP3	77858	38896	1	0.000	A	A	A	A
MP3	77860	38897	1	0.000	A	A	A	A
MP3	87738	43836	1	0.000	A	A	A	A
MP3	128246	64089	1	0.000	A	A	A	A
MP3	133890	66688	1	0.000	A	A	A	A
MP3	133892	66689	1	0.000	A	A	A	A
MP3	133894	66690	1	0.000	A	A	A	A
MP3	133896	66691	1	0.000	A	A	A	A
MP3	134290	66888	1	0.000	A	A	A	A
MP3	134314	66900	1	0.000	A	A	A	A
MP3	134944	67215	1	0.000	A	A	A	A
MP3	136472	67979	1	0.000	A	A	A	A
MP3	136504	67995	1	0.000	A	A	A	A
MP3	136510	67998	1	0.000	A	A	A	A
MP3	136512	67999	1	0.000	A	A	A	A
MP3	136514	68000	1	0.000	A	A	A	A
MP3	136516	68001	1	0.000	A	A	A	A
MP3	136822	68154	1	0.000	A	A	A	A
MP3	136998	68242	1	0.000	A	A	A	A
MP3	137006	68246	1	0.000	A	A	A	A
MP3	137008	68247	1	0.000	A	A	A	A
MP3	137014	68250	1	0.000	A	A	A	A
MP3	137084	68285	1	0.000	A	A	A	A
MP3	137086	68286	1	0.000	A	A	A	A
MP3	137204	68345	1	0.000	A	A	A	A
MP3	137242	68364	1	0.000	A	A	A	A
MP3	137246	68366	1	0.000	A	A	A	A
MP3	137248	68367	1	0.000	A	A	A	A
MP3	137272	68379	1	0.000	A	A	A	A
MP3	137308	68397	1	0.000	A	A	A	A
MP3	137310	68398	1	0.000	A	A	A	A
MP3	137336	68411	1	0.000	A	A	A	A
MP3	137460	68473	1	0.000	A	A	A	A
MP3	137462	68474	1	0.000	A	A	A	A
MP3	137464	68475	1	0.000	A	A	A	A
MP3	137466	68476	1	0.000	A	A	A	A
MP3	137566	68526	1	0.000	A	A	A	A
MP3	137568	68527	1	0.000	A	A	A	A
MP3	137570	68528	1	0.000	A	A	A	A
WAV	73567	36750	2	0.300	A	A	A	A
WAV	77859	38896	2	0.300	A	A	A	A
WAV	77861	38897	2	0.300	A	A	A	A
WAV	87739	43836	2	0.300	A	A	A	A
WAV	128247	64089	2	0.300	A	A	A	A
WAV	133891	66688	2	0.300	A	A	A	A
WAV	133893	66689	2	0.300	A	A	A	A
WAV	133895	66690	2	0.300	A	A	A	A
WAV	133897	66691	2	0.300	A	A	A	A
WAV	134291	66888	2	0.300	A	A	A	A
WAV	134315	66900	2	0.300	A	A	A	A
WAV	134945	67215	2	0.300	A	A	A	A
WAV	136473	67979	2	0.300	A	A	A	A
WAV	136505	67995	2	0.300	A	A	A	A
WAV	136511	67998	2	0.300	A	A	A	A
WAV	136513	67999	2	0.300	A	A	A	A
WAV	136515	68000	2	0.300	A	A	A	A
WAV	136517	68001	2	0.300	A	A	A	A
WAV	136823	68154	2	0.300	A	A	A	A
WAV	136999	68242	2	0.300	A	A	A	A
WAV	137007	68246	2	0.300	A	A	A	A
WAV	137009	68247	2	0.300	A	A	A	A
WAV	137015	68250	2	0.300	A	A	A	A
WAV	137085	68285	2	0.300	A	A	A	A
WAV	137087	68286	2	0.300	A	A	A	A
WAV	137205	68345	2	0.300	A	A	A	A
WAV	137243	68364	2	0.300	A	A	A	A
WAV	137247	68366	2	0.300	A	A	A	A
WAV	137249	68367	2	0.300	A	A	A	A
WAV	137273	68379	2	0.300	A	A	A	A
WAV	137309	68397	2	0.300	A	A	A	A
WAV	137311	68398	2	0.300	A	A	A	A
WAV	137337	68411	2	0.300	A	A	A	A
WAV	137461	68473	2	0.300	A	A	A	A
WAV	137463	68474	2	0.300	A	A	A	A
WAV	137465	68475	2	0.300	A	A	A	A
WAV	137467	68476	2	0.300	A	A	A	A
WAV	137567	68526	2	0.300	A	A	A	A
WAV	137569	68527	2	0.300	A	A	A	A
WAV	137571	68528	2	0.300	A	A	A	A