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 (
    61054, 61053, 61052, 61051, 61050, 61049, 
    61048, 61047, 61046, 61045, 61044, 
    61043, 61042, 61013, 61012, 71806, 
    71805, 71804, 71803, 71802, 71801, 
    71800, 71799, 71798, 71797, 71796, 
    60896, 60883, 60882, 60881, 60880, 
    60879, 60878, 60877, 60876, 60875, 
    60874, 60873, 60872, 60871
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00136

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	121810	60871	1	0.000	A	A	A	A
MP3	121812	60872	1	0.000	A	A	A	A
MP3	121814	60873	1	0.000	A	A	A	A
MP3	121816	60874	1	0.000	A	A	A	A
MP3	121818	60875	1	0.000	A	A	A	A
MP3	121820	60876	1	0.000	A	A	A	A
MP3	121822	60877	1	0.000	A	A	A	A
MP3	121824	60878	1	0.000	A	A	A	A
MP3	121826	60879	1	0.000	A	A	A	A
MP3	121828	60880	1	0.000	A	A	A	A
MP3	121830	60881	1	0.000	A	A	A	A
MP3	121832	60882	1	0.000	A	A	A	A
MP3	121834	60883	1	0.000	A	A	A	A
MP3	121860	60896	1	0.000	A	A	A	A
MP3	122092	61012	1	0.000	A	A	A	A
MP3	122094	61013	1	0.000	A	A	A	A
MP3	122152	61042	1	0.000	A	A	A	A
MP3	122154	61043	1	0.000	A	A	A	A
MP3	122156	61044	1	0.000	A	A	A	A
MP3	122158	61045	1	0.000	A	A	A	A
MP3	122160	61046	1	0.000	A	A	A	A
MP3	122162	61047	1	0.000	A	A	A	A
MP3	122164	61048	1	0.000	A	A	A	A
MP3	122166	61049	1	0.000	A	A	A	A
MP3	122168	61050	1	0.000	A	A	A	A
MP3	122170	61051	1	0.000	A	A	A	A
MP3	122172	61052	1	0.000	A	A	A	A
MP3	122174	61053	1	0.000	A	A	A	A
MP3	122176	61054	1	0.000	A	A	A	A
MP3	144106	71796	1	0.000	A	A	A	A
MP3	144108	71797	1	0.000	A	A	A	A
MP3	144110	71798	1	0.000	A	A	A	A
MP3	144112	71799	1	0.000	A	A	A	A
MP3	144114	71800	1	0.000	A	A	A	A
MP3	144116	71801	1	0.000	A	A	A	A
MP3	144118	71802	1	0.000	A	A	A	A
MP3	144120	71803	1	0.000	A	A	A	A
MP3	144122	71804	1	0.000	A	A	A	A
MP3	144124	71805	1	0.000	A	A	A	A
MP3	144126	71806	1	0.000	A	A	A	A
WAV	121811	60871	2	0.300	A	A	A	A
WAV	121813	60872	2	0.300	A	A	A	A
WAV	121815	60873	2	0.300	A	A	A	A
WAV	121817	60874	2	0.300	A	A	A	A
WAV	121819	60875	2	0.300	A	A	A	A
WAV	121821	60876	2	0.300	A	A	A	A
WAV	121823	60877	2	0.300	A	A	A	A
WAV	121825	60878	2	0.300	A	A	A	A
WAV	121827	60879	2	0.300	A	A	A	A
WAV	121829	60880	2	0.300	A	A	A	A
WAV	121831	60881	2	0.300	A	A	A	A
WAV	121833	60882	2	0.300	A	A	A	A
WAV	121835	60883	2	0.300	A	A	A	A
WAV	121861	60896	2	0.300	A	A	A	A
WAV	122093	61012	2	0.300	A	A	A	A
WAV	122095	61013	2	0.300	A	A	A	A
WAV	122153	61042	2	0.300	A	A	A	A
WAV	122155	61043	2	0.300	A	A	A	A
WAV	122157	61044	2	0.300	A	A	A	A
WAV	122159	61045	2	0.300	A	A	A	A
WAV	122161	61046	2	0.300	A	A	A	A
WAV	122163	61047	2	0.300	A	A	A	A
WAV	122165	61048	2	0.300	A	A	A	A
WAV	122167	61049	2	0.300	A	A	A	A
WAV	122169	61050	2	0.300	A	A	A	A
WAV	122171	61051	2	0.300	A	A	A	A
WAV	122173	61052	2	0.300	A	A	A	A
WAV	122175	61053	2	0.300	A	A	A	A
WAV	122177	61054	2	0.300	A	A	A	A
WAV	144107	71796	2	0.300	A	A	A	A
WAV	144109	71797	2	0.300	A	A	A	A
WAV	144111	71798	2	0.300	A	A	A	A
WAV	144113	71799	2	0.300	A	A	A	A
WAV	144115	71800	2	0.300	A	A	A	A
WAV	144117	71801	2	0.300	A	A	A	A
WAV	144119	71802	2	0.300	A	A	A	A
WAV	144121	71803	2	0.300	A	A	A	A
WAV	144123	71804	2	0.300	A	A	A	A
WAV	144125	71805	2	0.300	A	A	A	A
WAV	144127	71806	2	0.300	A	A	A	A