UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ekCvSVs6HFA19aJq63T8ufRqZvg9PEZcxZ6fRwTbX/U='
WHERE
key_id = '9e93b31e19a6beb34d371fd26e73b41f849a91f6a9278ac606db170cba54aa0a'
AND (
token = 'ekCvSVs6HFA19aJq63T8ufRqZvg9PEZcxZ6fRwTbX/U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)