UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NVwbmuthYr3toscIXU/lo2HAmuDJ02MDdxWQLF77/z0='
WHERE
key_id = '46ed1bbccf639a2062acd79ba1138f16860c4bc348cb8f5947d4fff045f4b202'
AND (
token = 'NVwbmuthYr3toscIXU/lo2HAmuDJ02MDdxWQLF77/z0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)