Translated node is not scheduled

Below my custom module main functions that solve this issue:

function moderation_scheduler_publishScheduled(){

    $moderation_storage = \Drupal::entityTypeManager()->getStorage('content_moderation_state');
    $moderation_info = \Drupal::service('content_moderation.moderation_information');
    $node_storage = \Drupal::entityManager()->getStorage('node');
    $state = 'published';
    
    // Get a date string suitable for use with entity query.
    $date = new DrupalDateTime();
    $date->setTimezone(new \DateTimezone(DateTimeItemInterface::STORAGE_TIMEZONE));
    $date = $date->format(DateTimeItemInterface::DATETIME_STORAGE_FORMAT);
    
    $languages = array_keys(\Drupal::languageManager()->getLanguages());
    
    $query = \Drupal::entityQuery('node')
        ->exists('field_scheduled_time')
        ->condition('field_scheduled_time.value', $date, '<=')
        ->latestRevision()
        ->sort('field_scheduled_time')
        ->sort('nid');
      // Disable access checks for this query.
      // @see https://www.drupal.org/node/2700209
      $query->accessCheck(FALSE);
      $nids = $query->execute();
      
      $nodes = moderation_scheduler_loadNodes($nids);

      if($nodes) {
          
        $default_language = \Drupal::languageManager()->getDefaultLanguage()->getId();

        foreach ($nodes as $node) {
            
            
        $d_node_vid = $node_storage->getLatestTranslationAffectedRevisionId($node->id(), $default_language);
        
        $d_node = $node_storage->loadRevision($d_node_vid)->getTranslation($default_language);
        
        $old_state = $d_node->get('moderation_state')->value;
        
        $languages = $node->getTranslationLanguages();
        
        $d_node->set('langcode', $default_language);
          
        $d_node->set('field_scheduled_time', NULL);
        
        $d_node->set('moderation_state', $state);  

        $d_node->setPublished(TRUE);
          
        $d_node->status = "1";
        
        foreach ($languages as $language) {
            $rev_lang = $language->getId();
          if($rev_lang != $default_language) {
              $d_node->removeTranslation($rev_lang);
              $t_node = moderation_scheduler_get_revision_from_field($node->id(), $rev_lang);

              if($t_node) {
                  $t_node->set('field_scheduled_time', NULL);
                  $t_node->set('moderation_state', $state);   
                  $t_node->setPublished(TRUE);  
                  $t_node->status = "1"; 
                  try {
                      // If transition is not valid, throw exception.
                      $translation = $d_node->addTranslation($rev_lang, $t_node->toArray())->save();
                      $t_node->save();
                      
                      $t_title = $t_node->getTitle();

                      $tranlsated = TRUE;
                      $t_lang = $rev_lang;
                      }      
                      catch (\InvalidArgumentException $exception) {
                          try {
                              $t_node->removeTranslation($default_language);
                               // If transition is not valid, throw exception.
                               $translation = $t_node->addTranslation($default_language, $d_node->toArray())->save();

                               $tranlsated = TRUE;
                               $t_lang = $rev_lang;
                               $t_title = $t_node->getTitle();
                              }      
                              catch (\InvalidArgumentException $exception) {
                               $t_title = $t_node->getTitle();
                               $t_node->save();
                              }                            
                      }
              }
          }
        }   
          $d_title = $d_node->getTitle();

          $d_node->save();
          $result[] = [
                          "node id" =>    $node->id(),
                          "old state" => $old_state,
                          "new state" => $state,
                          "lang" => $default_language. " (".$d_title.")",
                          "translation" => isset($translated) ? "default" : isset($t_lang) ? $t_lang. " (".$t_title.")" : "none",
                      ];   
          }          
      }

    if(isset($result)) {
        //moderation_scheduler_clear_scheduled_time_field();
    }
    if(isset($result)) {
        return $result;
    } else {
        return ["no scheduled content"];
    }
}
function moderation_scheduler_get_revision_from_field($nid, $langcode) {
    // Get a date string suitable for use with entity query.
    $node_storage = \Drupal::entityManager()->getStorage('node');
    $date = new DrupalDateTime();
    $date->setTimezone(new \DateTimezone(DateTimeItemInterface::STORAGE_TIMEZONE));
    $date = $date->format(DateTimeItemInterface::DATETIME_STORAGE_FORMAT);
    $connection = \Drupal::database();
    $query = $connection->query("SELECT revision_id, langcode, field_scheduled_time_value, entity_id FROM {node_revision__field_scheduled_time} WHERE langcode = :langcode", [
  ':langcode' => $langcode,
            ]);

    $revisions = $query->fetchAll();
    if($revisions) {
        $revision = end($revisions);
            //get revision id from the field
            $revision_id = $revision->revision_id;
            $vid = $revision->entity_id;
            $schedule = $revision->field_scheduled_time_value;
            $lang = $revision->langcode;
            if($lang == $langcode && $schedule <= $date) {
                //Load node revision with proper langcode and translation
                $rev = $node_storage->loadRevision($revision_id)->getTranslation($langcode); 
                if($rev) {
                    $rev->set('langcode', $langcode);
                    return $rev;
                }
            }
    }
}

Hi nope in admin/scheduled/tab was only the latest saved translation, the node is only one but with 2 tranlsations.

My suggestion is to get the revision id from the field u create for scheduling and then load Revision by field revision id.

To fix my use case i develop my own module so we can use with composer dependency, if can help have a look:

https://www.drupal.org/project/moderation_scheduler

Regards