LockService.php

<?php

class LockService
{
    public function tryAcquireLocationLock(
        LocationLock $lock,
        IdInterface $owner,
        ?DateTimeImmutable $expirationDate
    ): bool {
        try {
            $affectedRows = $this->connection->insert(
                self::TABLE_NAME,
                [
                    'host' => $lock->host(),
                    'path' => $lock->path(),
                    'token' => $lock->token()->__toString(),
                    'owner' => $owner->__toString(),
                    'created_at' => date('Y-m-d H:i:s'),
                    'expires_at' => !$expirationDate ? null : $expirationDate->format('Y-m-d H:i:s'),
                ]
            );
        } catch (UniqueConstraintViolationException $e) {
            return false;
        }

        return $affectedRows !== 0;
    }
}

usage.php

<?php

        $locationLock = $this->locationService->tryAcquireLocationLock(
            LocationLock::fromString($host, $path, $locationLockToken),
            $requestId,
            $expirationDate
        );

        while (false === $locationLock) {
            $proposalId = $this->proposalIdGenerator->getUniqueId();
            $path = $proposalId;

            $locationLock = $this->locationService->tryAcquireLocationLock(
                LocationLock::fromString($host, $path, $locationLockToken),
                $requestId,
                $expirationDate
            );
        }