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 (
    69180, 69179, 69164, 69106, 69087, 68926, 
    68786, 68713, 68712, 68932, 69104, 
    69086, 68852, 68846, 68990, 68930, 
    68603, 68602, 68931, 68984, 68740, 
    68983, 68982, 68981, 68980, 68979, 
    68978, 68977, 68976, 68975, 68974, 
    68973, 68972, 68971, 68970, 68969, 
    68968, 68967, 68966, 68965
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00112

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	137718	68602	1	0.000	A	A	A	A
MP3	137720	68603	1	0.000	A	A	A	A
MP3	137938	68712	1	0.000	A	A	A	A
MP3	137940	68713	1	0.000	A	A	A	A
MP3	137994	68740	1	0.000	A	A	A	A
MP3	138086	68786	1	0.000	A	A	A	A
MP3	138206	68846	1	0.000	A	A	A	A
MP3	138218	68852	1	0.000	A	A	A	A
MP3	138366	68926	1	0.000	A	A	A	A
MP3	138374	68930	1	0.000	A	A	A	A
MP3	138376	68931	1	0.000	A	A	A	A
MP3	138378	68932	1	0.000	A	A	A	A
MP3	138444	68965	1	0.000	A	A	A	A
MP3	138446	68966	1	0.000	A	A	A	A
MP3	138448	68967	1	0.000	A	A	A	A
MP3	138450	68968	1	0.000	A	A	A	A
MP3	138452	68969	1	0.000	A	A	A	A
MP3	138454	68970	1	0.000	A	A	A	A
MP3	138456	68971	1	0.000	A	A	A	A
MP3	138458	68972	1	0.000	A	A	A	A
MP3	138460	68973	1	0.000	A	A	A	A
MP3	138462	68974	1	0.000	A	A	A	A
MP3	138464	68975	1	0.000	A	A	A	A
MP3	138466	68976	1	0.000	A	A	A	A
MP3	138468	68977	1	0.000	A	A	A	A
MP3	138470	68978	1	0.000	A	A	A	A
MP3	138472	68979	1	0.000	A	A	A	A
MP3	138474	68980	1	0.000	A	A	A	A
MP3	138476	68981	1	0.000	A	A	A	A
MP3	138478	68982	1	0.000	A	A	A	A
MP3	138480	68983	1	0.000	A	A	A	A
MP3	138482	68984	1	0.000	A	A	A	A
MP3	138494	68990	1	0.000	A	A	A	A
MP3	138686	69086	1	0.000	A	A	A	A
MP3	138688	69087	1	0.000	A	A	A	A
MP3	138722	69104	1	0.000	A	A	A	A
MP3	138726	69106	1	0.000	A	A	A	A
MP3	138842	69164	1	0.000	A	A	A	A
MP3	138872	69179	1	0.000	A	A	A	A
MP3	138874	69180	1	0.000	A	A	A	A
WAV	137719	68602	2	0.300	A	A	A	A
WAV	137721	68603	2	0.300	A	A	A	A
WAV	137939	68712	2	0.300	A	A	A	A
WAV	137941	68713	2	0.300	A	A	A	A
WAV	137995	68740	2	0.300	A	A	A	A
WAV	138087	68786	2	0.300	A	A	A	A
WAV	138207	68846	2	0.300	A	A	A	A
WAV	138219	68852	2	0.300	A	A	A	A
WAV	138367	68926	2	0.300	A	A	A	A
WAV	138375	68930	2	0.300	A	A	A	A
WAV	138377	68931	2	0.300	A	A	A	A
WAV	138379	68932	2	0.300	A	A	A	A
WAV	138445	68965	2	0.300	A	A	A	A
WAV	138447	68966	2	0.300	A	A	A	A
WAV	138449	68967	2	0.300	A	A	A	A
WAV	138451	68968	2	0.300	A	A	A	A
WAV	138453	68969	2	0.300	A	A	A	A
WAV	138455	68970	2	0.300	A	A	A	A
WAV	138457	68971	2	0.300	A	A	A	A
WAV	138459	68972	2	0.300	A	A	A	A
WAV	138461	68973	2	0.300	A	A	A	A
WAV	138463	68974	2	0.300	A	A	A	A
WAV	138465	68975	2	0.300	A	A	A	A
WAV	138467	68976	2	0.300	A	A	A	A
WAV	138469	68977	2	0.300	A	A	A	A
WAV	138471	68978	2	0.300	A	A	A	A
WAV	138473	68979	2	0.300	A	A	A	A
WAV	138475	68980	2	0.300	A	A	A	A
WAV	138477	68981	2	0.300	A	A	A	A
WAV	138479	68982	2	0.300	A	A	A	A
WAV	138481	68983	2	0.300	A	A	A	A
WAV	138483	68984	2	0.300	A	A	A	A
WAV	138495	68990	2	0.300	A	A	A	A
WAV	138687	69086	2	0.300	A	A	A	A
WAV	138689	69087	2	0.300	A	A	A	A
WAV	138723	69104	2	0.300	A	A	A	A
WAV	138727	69106	2	0.300	A	A	A	A
WAV	138843	69164	2	0.300	A	A	A	A
WAV	138873	69179	2	0.300	A	A	A	A
WAV	138875	69180	2	0.300	A	A	A	A