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 (
    60507, 60506, 60505, 60504, 60503, 60716, 
    60430, 60427, 60422, 60420, 60413, 
    60412, 60408, 60440, 60436, 60042, 
    60013, 60012, 60379, 60342, 60341, 
    60340, 60339, 60338, 60337, 60336, 
    60335, 60334, 60333, 60332, 60331, 
    60250, 59941, 59940, 59939, 59938, 
    59937, 59936, 59935, 59934
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00127

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	119936	59934	1	0.000	A	A	A	A
MP3	119938	59935	1	0.000	A	A	A	A
MP3	119940	59936	1	0.000	A	A	A	A
MP3	119942	59937	1	0.000	A	A	A	A
MP3	119944	59938	1	0.000	A	A	A	A
MP3	119946	59939	1	0.000	A	A	A	A
MP3	119948	59940	1	0.000	A	A	A	A
MP3	119950	59941	1	0.000	A	A	A	A
MP3	120092	60012	1	0.000	A	A	A	A
MP3	120094	60013	1	0.000	A	A	A	A
MP3	120152	60042	1	0.000	A	A	A	A
MP3	120568	60250	1	0.000	A	A	A	A
MP3	120730	60331	1	0.000	A	A	A	A
MP3	120732	60332	1	0.000	A	A	A	A
MP3	120734	60333	1	0.000	A	A	A	A
MP3	120736	60334	1	0.000	A	A	A	A
MP3	120738	60335	1	0.000	A	A	A	A
MP3	120740	60336	1	0.000	A	A	A	A
MP3	120742	60337	1	0.000	A	A	A	A
MP3	120744	60338	1	0.000	A	A	A	A
MP3	120746	60339	1	0.000	A	A	A	A
MP3	120748	60340	1	0.000	A	A	A	A
MP3	120750	60341	1	0.000	A	A	A	A
MP3	120752	60342	1	0.000	A	A	A	A
MP3	120826	60379	1	0.000	A	A	A	A
MP3	120884	60408	1	0.000	A	A	A	A
MP3	120892	60412	1	0.000	A	A	A	A
MP3	120894	60413	1	0.000	A	A	A	A
MP3	120908	60420	1	0.000	A	A	A	A
MP3	120912	60422	1	0.000	A	A	A	A
MP3	120922	60427	1	0.000	A	A	A	A
MP3	120928	60430	1	0.000	A	A	A	A
MP3	120940	60436	1	0.000	A	A	A	A
MP3	120948	60440	1	0.000	A	A	A	A
MP3	121074	60503	1	0.000	A	A	A	A
MP3	121076	60504	1	0.000	A	A	A	A
MP3	121078	60505	1	0.000	A	A	A	A
MP3	121080	60506	1	0.000	A	A	A	A
MP3	121082	60507	1	0.000	A	A	A	A
MP3	121500	60716	1	0.000	A	A	A	A
WAV	119937	59934	2	0.300	A	A	A	A
WAV	119939	59935	2	0.300	A	A	A	A
WAV	119941	59936	2	0.300	A	A	A	A
WAV	119943	59937	2	0.300	A	A	A	A
WAV	119945	59938	2	0.300	A	A	A	A
WAV	119947	59939	2	0.300	A	A	A	A
WAV	119949	59940	2	0.300	A	A	A	A
WAV	119951	59941	2	0.300	A	A	A	A
WAV	120093	60012	2	0.300	A	A	A	A
WAV	120095	60013	2	0.300	A	A	A	A
WAV	120153	60042	2	0.300	A	A	A	A
WAV	120569	60250	2	0.300	A	A	A	A
WAV	120731	60331	2	0.300	A	A	A	A
WAV	120733	60332	2	0.300	A	A	A	A
WAV	120735	60333	2	0.300	A	A	A	A
WAV	120737	60334	2	0.300	A	A	A	A
WAV	120739	60335	2	0.300	A	A	A	A
WAV	120741	60336	2	0.300	A	A	A	A
WAV	120743	60337	2	0.300	A	A	A	A
WAV	120745	60338	2	0.300	A	A	A	A
WAV	120747	60339	2	0.300	A	A	A	A
WAV	120749	60340	2	0.300	A	A	A	A
WAV	120751	60341	2	0.300	A	A	A	A
WAV	120753	60342	2	0.300	A	A	A	A
WAV	120827	60379	2	0.300	A	A	A	A
WAV	120885	60408	2	0.300	A	A	A	A
WAV	120893	60412	2	0.300	A	A	A	A
WAV	120895	60413	2	0.300	A	A	A	A
WAV	120909	60420	2	0.300	A	A	A	A
WAV	120913	60422	2	0.300	A	A	A	A
WAV	120923	60427	2	0.300	A	A	A	A
WAV	120929	60430	2	0.300	A	A	A	A
WAV	120941	60436	2	0.300	A	A	A	A
WAV	120949	60440	2	0.300	A	A	A	A
WAV	121075	60503	2	0.300	A	A	A	A
WAV	121077	60504	2	0.300	A	A	A	A
WAV	121079	60505	2	0.300	A	A	A	A
WAV	121081	60506	2	0.300	A	A	A	A
WAV	121083	60507	2	0.300	A	A	A	A
WAV	121501	60716	2	0.300	A	A	A	A