UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RPKles35oZ6OoiAbG9RdG/7+n3pd+x0DAx0t9cy8iME='
WHERE
key_id = '8f2bf67e551bb54bc9e6f9926eb738156328e54169f58d1e5b0d9a49119cd48b'
AND (
token = 'RPKles35oZ6OoiAbG9RdG/7+n3pd+x0DAx0t9cy8iME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)