UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2nPVVITiXKMki8JRz2ZUnzmFOL/IiNK0RG+w0uPHDOM='
WHERE
key_id = '9491cef70ae3dc80a7823bd8e4b9f759fec13b173a2f6c7c99b84d3ad0cd2a46'
AND (
token = '2nPVVITiXKMki8JRz2ZUnzmFOL/IiNK0RG+w0uPHDOM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)