Have I written the stored procedure code correctly?

Question

MySQL

DELIMITER //

BEGIN

SET @email = (SELECT email FROM accounts WHERE id = uid LIMIT 1);
SET @rdt = (SELECT regDT FROM accounts WHERE id = uid LIMIT 1);
SET @now = NOW();

IF @email IS NULL AND @now > DATE_ADD(@rdt, INTERVAL 7 DAY) THEN 
UPDATE accounts SET blocked = 1 WHERE id = uid LIMIT 1;
END IF;

END//

The procedure receives the user ID [uid] as input, then it receives the registration date and email address as variables. mail. Next, it checks if the user has entered his email and how many days have passed since the registration date. If the mail is not entered and more than a week has passed since the date of registration, then the account is blocked.
accounts table:

CREATE TABLE IF NOT EXISTS `accounts` (
  `id` bigint(20) NOT NULL COMMENT 'Идентификатор пользователя',
  `login` tinytext NOT NULL COMMENT 'Логин',
  `pass` tinytext NOT NULL COMMENT 'Пароль',
  `email` tinytext COMMENT 'Почта',
  `regDT` datetime NOT NULL COMMENT 'Дата и время регистрации',
  `regIP` varchar(15) NOT NULL DEFAULT '0.0.0.0' COMMENT 'Регистрационный IP',
  `blocked` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Заблокирован?'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Аккаунты';

Answer 1

UPDATE `accounts` 
    SET `blocked` = 1
    WHERE `email` IS NULL 
        AND `regDT` < NOW() - INTERVAL 7 DAY
        AND `id` = :uid

Well, or remove the last line if you need to block all such records at once.

Answer 2

Normal storage. but you can try to do an UPDATE with one request