UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DShTS9s/90Lhntw0HpHGSOgRBm/SHnr9XZhLM6wYKq8='
WHERE
key_id = 'eb2882e3e1d7fc8b1c7f2f539c5d2591f8d32827d590ea13622f694997bc39d4'
AND (
token = 'DShTS9s/90Lhntw0HpHGSOgRBm/SHnr9XZhLM6wYKq8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)