I need help with the following SQL:-

```
UPDATE `mg_catalog_category_entity_varchar` AS t1 INNER JOIN `mg_catalog_category_entity`
AS t2 ON t1.`entity_id`= t2.`entity_id`
SET t1.`value` = CONCAT('US Sports Goods ', t1.`value`, ' | My Site Name') 
WHERE t2.`path` LIKE '1/2642%' AND t2.`level` > 1 AND t1.`attribute_id` = 40

```

My problem is that the `t1.value` field in the `CONCAT()` statement needs to pull the `t1.value` WHERE `t1.attribute_id = 35` and I am struggling to figure out how to correctly specify this within the `CONCAT()` statement.