UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E7N1OcZ5AhxBCyT+MgZ77PqfLnIcVJWz/uzLcBVWbd4='
WHERE
key_id = 'c32e66303e75e4a6d68969691e1c85cf03dde14e80bd589291cbd1b00f856fd7'
AND (
token = 'E7N1OcZ5AhxBCyT+MgZ77PqfLnIcVJWz/uzLcBVWbd4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)