UPDATE collectify.order_sku os, (SELECT
                                   id,
                                   migros_code
                                 FROM collectify.store) s
SET os.store_id = s.migros_code
WHERE os.store_id = s.id;