UPDATE `oc_product_description` pd
JOIN `oc_attribute_description` ad
JOIN `oc_product_attribute` pa2 ON pa2.attribute_id = pa2.attribute_id AND pa2.attribute_id = 2
JOIN `oc_product_attribute` pa4 ON pa4.attribute_id = pa4.attribute_id AND pa4.attribute_id = 4
JOIN `oc_product_attribute` pa1 ON pa1.attribute_id = pa1.attribute_id AND pa1.attribute_id = 1
JOIN `oc_product_attribute` pa10 ON pa10.attribute_id = pa10.attribute_id AND pa10.attribute_id = 10
JOIN `oc_product_attribute` pl ON pl.language_id = pl.language_id AND pl.language_id = 4
JOIN `oc_product_attribute` pap ON pap.product_id = pap.product_id
JOIN `oc_product_attribute` pat ON pat.text = pat.text

set pd.`description`=
concat ('Вы можете приобрести ',pd.`name`,' с гарантией от производителя.',' ',ad.`name`,' ',pat.`text`,' на ',pat.`text`)

where pd.`product_id` = 102
and pd.`language_id` = 4
and ad.`language_id` = pl.`language_id`
and pl.`language_id` = pd.`language_id`

or ad.`attribute_id` = pa2.`attribute_id`
or ad.`attribute_id` = pa4.`attribute_id`
or ad.`attribute_id` = pa1.`attribute_id`
or ad.`attribute_id` = pa10.`attribute_id`

and pap.`product_id` = pd.`product_id`