Adds a "chunkSimple" method to Laravel's query builder, so where(Has) clauses don't break with pagination. This might happen if you update the same model in the chunk callback, thus skipping rows. Simply swap out chunk with chunkSimple and hey, presto!

DatabaseServiceProvider.php

<?php

namespace App\Providers;

use Illuminate\Database\Eloquent\Builder;

class DatabaseServiceProvider extends ServiceProvider
{
    /**
     * Bootstrap any application services.
     *
     * @return void
     */
    public function boot()
    {
        // Chunking that does not break with where clauses
        Builder::macro('chunkSimple', function (int $size, callable $callable) {
            $page = 1;

            while (($chunk = $this->limit($size)->get())->count() >= $size) {
                if ($callable($chunk, $page++) === false) {
                    return false;
                }
            }

            return true;
        });
    }
};