$table_one_records = $table_one->find('all')->where(['some xyz condition']);
foreach($table_one_records as $key => $value){
    $table_two_record = $table_two->find('all')->where(['any condition goes here']);

    UPDATE table_two SET column1 = $table_two_record['column2'], column2 = null WHERE `id` = $table_two_record['id'];

}